Access as frontend

intefix

New member
Local time
Today, 21:49
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?
 
you must have the ODBC drivers for SQL express installed.
 
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
 
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
 
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
 
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

Back
Top Bottom