Access as frontend (1 Viewer)

intefix

New member
Local time
Today, 12:58
Joined
Feb 19, 2013
Messages
9
Hello...
I have a file customers.accdb as application.
All is here except tables as linked from sharing intranet forder on win xp...
When use application more 3-5 ppls the app is very slow.
What is better method to convert that in sql linking tables?

I have installed a SQL express 2008 in win xp as server...but not show in ODBC connection...
Any help?
 

Ranman256

Well-known member
Local time
Today, 06:58
Joined
Apr 9, 2015
Messages
4,337
you must have the ODBC drivers for SQL express installed.
 

intefix

New member
Local time
Today, 12:58
Joined
Feb 19, 2013
Messages
9
Hello guys again.
I'm user Access as you know.:confused::confused::confused::confused:
All my apps was splitting with Access 2k7 backend in localy server as remote folder and also Access 2k7 all things as client.
Now have users who want connect via internet to database with vpn.
I has migration mdb server database in MsSQL. All ok.
Also make new client with ODBC in server ok.
With a normal data 100.000 records new app with ODBC link tables is very very slow compare old way (external data, link tables in access)
What is better settings should I make to the Windows server to MsSQLexpress?
What code need to client side to relink to have better speed than now?
SERVER. Windows Server 2012 MsSQL 2017express
CLIENT Windows 2010 8Gram 8cores, Access 2013
Will make difficult for me to transform all that in PHP etc WEB way....
King Regards
 

dynamictiger

Registered User.
Local time
Today, 10:58
Joined
Feb 3, 2002
Messages
270
With a normal data 100.000 records new app with ODBC link tables is very very slow compare old way (external data, link tables in access)

Try optimising the queries for SQL
 

CJ_London

Super Moderator
Staff member
Local time
Today, 10:58
Joined
Feb 19, 2013
Messages
16,553
you need to look at your router performance, perhaps it needs to have a higher capacity.

Also consider using terminal server or citrix or perhaps migrate your sql server to azure
 

intefix

New member
Local time
Today, 12:58
Joined
Feb 19, 2013
Messages
9
you need to look at your router performance, perhaps it needs to have a higher capacity.

Also consider using terminal server or citrix or perhaps migrate your sql server to azure
About Router: The same hardware use to both ways.
Also have other apps (Other products) who working perfect with more records.
I believe in my case need better setup in server side and better VB code in client side....
 

Users who are viewing this thread

Top Bottom